﻿if exists (select * from sysobjects where name like N'%sp_CongTy_GetAll%')
	drop proc sp_CongTy_GetAll
go
create proc sp_CongTy_GetAll
as
begin
	SELECT [MaCongTy]
      ,[TenCongTy]
      ,[DiaChi]
      ,[DienThoai]
      ,[Fax]
      ,[Website]
      ,[TinhThanh]
      ,[QuanHuyen]
      ,[GiamDoc]
      ,[KeToanTruong]
      ,[ThuQuy]
      ,[MST]
      ,[CoQuanThue]
      ,[TaiKhoan]
      ,[NganHang]
      ,[MauHD]
      ,[Logo]
      ,[CreateBy]
      ,[ModifiedBy]
      ,[ModifiedOn]
  FROM CONGTY
end